Tabela LStockItemPackage

Definicja tabeli LStockItemPackage

Name

LStockItemPackage

Code

LStockItemPackage

Comment

 


Lista kolumn tabeli LStockItemPackage

Name

Code

PackageID

PackageID

StockTypeID

StockTypeID

StockItemID

StockItemID

StockPackageTypeID

StockPackageTypeID

DefaultItem

DefaultItem

Price

Price

StartDT

StartDT

StopDT

StopDT


Kolumna PackageID tabeli LStockItemPackage

Definicja kolumny PackageID tabeli LStockItemPackage

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockTypeID tabeli LStockItemPackage

Definicja kolumny StockTypeID tabeli LStockItemPackage

Name

StockTypeID

Code

StockTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockItemID tabeli LStockItemPackage

Definicja kolumny StockItemID tabeli LStockItemPackage

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna StockPackageTypeID tabeli LStockItemPackage

Definicja kolumny StockPackageTypeID tabeli LStockItemPackage

Name

StockPackageTypeID

Code

StockPackageTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DefaultItem tabeli LStockItemPackage

Definicja kolumny DefaultItem tabeli LStockItemPackage

Name

DefaultItem

Code

DefaultItem

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Price tabeli LStockItemPackage

Definicja kolumny Price tabeli LStockItemPackage

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LStockItemPackage

Definicja kolumny StartDT tabeli LStockItemPackage

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Kontrola aktualizacji opakowan dla zasobów


Kolumna StopDT tabeli LStockItemPackage

Definicja kolumny StopDT tabeli LStockItemPackage

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Kontrola aktualizacji opakowan dla zasobów


Lista kluczy tabeli LStockItemPackage

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LStockItemPackage

Definicja klucza Identifier_1 tabeli LStockItemPackage

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment